Map; UP and DOWN arrow 18

Transforming data: (before mapping)

Step1

Change the data Category of Admin1 to State Admin2 to County and Admin 3 to City and Locattion to Places. then

Click Home then click Transform Data

Step2

On Power Query Editor:

Change Admin1 to Region; Admin2 to Zone Amin3 to Sub_zone

Then click at the left corner of Power Query editor Close and Apply.

Step3

Visual = 3: Choose Filled map on the visualization

·         Drag the map (Filled Map) to the upper right corner

Fields Tab:

·         Location: Region

·         Tooltips: Deaths per Mth/ %Mom/ %YoY

Format Tab

·         General: X Position = 757, Y Position = 91, Width = 515, Height = 310

Step4

·         Data Colors:  press Default color = fx function, Format by = Color scale, based on field = Deaths per Mth, Diverging = On, Minimum = #E6E6E6, Center = #ECC846, Maximum = #000000.

·         Map controls: Auto Zoom = On, Zoom Buttons = On, Lasso button = off, Geocoding culture = Auto

·         Map styles: Theme = Road, Show labels = On

·         Title: On, Title text = By Region/State, Word wrap = Off, Font Color = #FFFFFF, Background color = #000000, Alignment = Center, Text size = 14, Font family = Segoe UI

·         Background: On, color = #FFFFFFF, Transparency = 0%

·         Lock aspect = off

·         Border: On, Color = #E6E6E6, Radius = 0

·         Shadow: Off

·         Tooltip = On, Type = Report Page, Page = Auto, Label Text color = #C8C8C8, Value text color = #EAEAEA, Text size = 9, Font family = Segoe UI, Background color = #333333, Transparency = 5%

·         Visual header = On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon color = #333333, Visual information icon = On, Visual warning icon = On, Drill on drop down = On, drill up icon = On, Drill down icon = On, Show next level icon = On, Expand to next level icon = On, Pin icon = On, Focus mode icon = On, Filter icon = On, See data layout icon = On, More Options icon = On

Step5

 

·         Legend: Click on image, Select the legend from the file: Minimize the size of the legend and drag it to the map; Click on text box, background Off; Write Low and High in the text box; Font size = 10, Font = Segoe UI, Text = Bold; Drag the text to the legend

Step6

Create New Measure by right clicking All measures

NB:           RED = #EC1304

                  Green = #73B761

Type: the dax formula  Indicator MOM = If([%MOM] < 0,UNICHAR(9660),UNICHAR(9650))

Again, Create New Measure by right clicking All measures then

Type: Indicator YOY = If([%YOY] < 0, UNICHAR(9660),UNICHAR(9650))

Save by clicking right sign next to X

Next

From Visualization click Card minimize paste it to %MOM

Under Field:

Drag Indicator MOM from All Measure and paste it field

Under Format: General




 Under: Data label press function fx; text size in Data label is 27


Step7

Similarly For Indicator YOY:

Create New Measure by right clicking All measures

Type: the dax formula  Indicator YOY = If([%MOM] < 0,UNICHAR(9660),UNICHAR(9650))

Again, Create New Measure by right clicking All measures then

Type: Indicator Indicator YOY = If([%YOY] < 0,UNICHAR(9660),UNICHAR(9650))

Save by clicking right sign next to X

Next

From Visualization  click Card  and minimize and paste it to %YoY

Under Field:



Under: Data label press function fx




Use the following step by step Gif to create the map

For Step1


For Step2


For Step3


For Step4


For Step5


For Step6


For Step7


Transform Data in Power BI

https://www.youtube.com/watch?v=6g4PKRHC1UQ

Add colored KPI arrows to power Bi 2019 version

https://www.youtube.com/watch?v=cboA5AtAPeg&t=142s

PowerBi - Map visualization

https://www.youtube.com/watch?v=Lk_GZiYpr7Q